package com.calvin.entity;

import java.util.Date;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.format.NumberFormat;

import cn.hutool.core.date.DatePattern;
import lombok.EqualsAndHashCode;
import lombok.Getter;
import lombok.Setter;

@Getter
@Setter
@EqualsAndHashCode
//@ExcelIgnoreUnannotated
public class ExcelEntity3 {

	//@ExcelProperty("字符串标题")
	
//	@ExcelProperty("业务日期")
//	private String billdate;
//	@ExcelProperty("单据编号")
//    private String billcode;
//	@ExcelProperty("单据序号")
//    private Integer billsn;
//	@ExcelProperty("入库开票人")
//	private String checkRealName;
	//index 列的索引,可用于指定该数据写入那一列
	@ExcelProperty(value = "姓名标题",index = 0)
	private String name;
	@ExcelProperty(value ="合并标题",index = 1)
    private Integer age;
	@ExcelProperty(value ="城市标题",index = 2)
	private String city;
	
	@DateTimeFormat(DatePattern.CHINESE_DATE_TIME_PATTERN)
	@ExcelProperty("日期标题")
	private Date date;
	
	@NumberFormat("#.##%")
    @ExcelProperty(value = "数字标题")
	private Double doubleData;
}
